using System; 
using System.Text; 
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration; 
using System.Xml; 
using System.Xml.Serialization;
using SubSonic; 
using SubSonic.Utilities;
namespace CXDB{
    /// <summary>
    /// Strongly-typed collection for the VwProviderRep class.
    /// </summary>
    [Serializable]
    public partial class VwProviderRepCollection : ReadOnlyList<VwProviderRep, VwProviderRepCollection>
    {        
        public VwProviderRepCollection() {}
    }
    /// <summary>
    /// This is  Read-only wrapper class for the vw_provider_rep view.
    /// </summary>
    [Serializable]
    public partial class VwProviderRep : ReadOnlyRecord<VwProviderRep>, IReadOnlyRecord
    {
    
	    #region Default Settings
	    protected static void SetSQLProps() 
	    {
		    GetTableSchema();
	    }
	    #endregion
        #region Schema Accessor
	    public static TableSchema.Table Schema
        {
            get
            {
                if (BaseSchema == null)
                {
                    SetSQLProps();
                }
                return BaseSchema;
            }
        }
    	
        private static void GetTableSchema() 
        {
            if(!IsSchemaInitialized)
            {
                //Schema declaration
                TableSchema.Table schema = new TableSchema.Table("vw_provider_rep", TableType.View, DataService.GetInstance("CXDB"));
                schema.Columns = new TableSchema.TableColumnCollection();
                schema.SchemaName = @"dbo";
                //columns
                
                TableSchema.TableColumn colvarId = new TableSchema.TableColumn(schema);
                colvarId.ColumnName = "ID";
                colvarId.DataType = DbType.Int32;
                colvarId.MaxLength = 0;
                colvarId.AutoIncrement = false;
                colvarId.IsNullable = false;
                colvarId.IsPrimaryKey = false;
                colvarId.IsForeignKey = false;
                colvarId.IsReadOnly = false;
                
                schema.Columns.Add(colvarId);
                
                TableSchema.TableColumn colvarProviderName = new TableSchema.TableColumn(schema);
                colvarProviderName.ColumnName = "ProviderName";
                colvarProviderName.DataType = DbType.String;
                colvarProviderName.MaxLength = 100;
                colvarProviderName.AutoIncrement = false;
                colvarProviderName.IsNullable = true;
                colvarProviderName.IsPrimaryKey = false;
                colvarProviderName.IsForeignKey = false;
                colvarProviderName.IsReadOnly = false;
                
                schema.Columns.Add(colvarProviderName);
                
                TableSchema.TableColumn colvarDeviceName = new TableSchema.TableColumn(schema);
                colvarDeviceName.ColumnName = "DeviceName";
                colvarDeviceName.DataType = DbType.String;
                colvarDeviceName.MaxLength = 100;
                colvarDeviceName.AutoIncrement = false;
                colvarDeviceName.IsNullable = true;
                colvarDeviceName.IsPrimaryKey = false;
                colvarDeviceName.IsForeignKey = false;
                colvarDeviceName.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeviceName);
                
                TableSchema.TableColumn colvarShamTime = new TableSchema.TableColumn(schema);
                colvarShamTime.ColumnName = "Sham_time";
                colvarShamTime.DataType = DbType.DateTime;
                colvarShamTime.MaxLength = 0;
                colvarShamTime.AutoIncrement = false;
                colvarShamTime.IsNullable = true;
                colvarShamTime.IsPrimaryKey = false;
                colvarShamTime.IsForeignKey = false;
                colvarShamTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarShamTime);
                
                TableSchema.TableColumn colvarShamProject = new TableSchema.TableColumn(schema);
                colvarShamProject.ColumnName = "Sham_project";
                colvarShamProject.DataType = DbType.String;
                colvarShamProject.MaxLength = 100;
                colvarShamProject.AutoIncrement = false;
                colvarShamProject.IsNullable = true;
                colvarShamProject.IsPrimaryKey = false;
                colvarShamProject.IsForeignKey = false;
                colvarShamProject.IsReadOnly = false;
                
                schema.Columns.Add(colvarShamProject);
                
                TableSchema.TableColumn colvarShamDetail = new TableSchema.TableColumn(schema);
                colvarShamDetail.ColumnName = "Sham_detail";
                colvarShamDetail.DataType = DbType.String;
                colvarShamDetail.MaxLength = 1073741823;
                colvarShamDetail.AutoIncrement = false;
                colvarShamDetail.IsNullable = true;
                colvarShamDetail.IsPrimaryKey = false;
                colvarShamDetail.IsForeignKey = false;
                colvarShamDetail.IsReadOnly = false;
                
                schema.Columns.Add(colvarShamDetail);
                
                TableSchema.TableColumn colvarXinghuTime = new TableSchema.TableColumn(schema);
                colvarXinghuTime.ColumnName = "Xinghu_time";
                colvarXinghuTime.DataType = DbType.DateTime;
                colvarXinghuTime.MaxLength = 0;
                colvarXinghuTime.AutoIncrement = false;
                colvarXinghuTime.IsNullable = true;
                colvarXinghuTime.IsPrimaryKey = false;
                colvarXinghuTime.IsForeignKey = false;
                colvarXinghuTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarXinghuTime);
                
                TableSchema.TableColumn colvarXinghuProject = new TableSchema.TableColumn(schema);
                colvarXinghuProject.ColumnName = "Xinghu_project";
                colvarXinghuProject.DataType = DbType.String;
                colvarXinghuProject.MaxLength = 100;
                colvarXinghuProject.AutoIncrement = false;
                colvarXinghuProject.IsNullable = true;
                colvarXinghuProject.IsPrimaryKey = false;
                colvarXinghuProject.IsForeignKey = false;
                colvarXinghuProject.IsReadOnly = false;
                
                schema.Columns.Add(colvarXinghuProject);
                
                TableSchema.TableColumn colvarXinghuDetail = new TableSchema.TableColumn(schema);
                colvarXinghuDetail.ColumnName = "Xinghu_detail";
                colvarXinghuDetail.DataType = DbType.String;
                colvarXinghuDetail.MaxLength = 1073741823;
                colvarXinghuDetail.AutoIncrement = false;
                colvarXinghuDetail.IsNullable = true;
                colvarXinghuDetail.IsPrimaryKey = false;
                colvarXinghuDetail.IsForeignKey = false;
                colvarXinghuDetail.IsReadOnly = false;
                
                schema.Columns.Add(colvarXinghuDetail);
                
                TableSchema.TableColumn colvarContractTime = new TableSchema.TableColumn(schema);
                colvarContractTime.ColumnName = "Contract_time";
                colvarContractTime.DataType = DbType.DateTime;
                colvarContractTime.MaxLength = 0;
                colvarContractTime.AutoIncrement = false;
                colvarContractTime.IsNullable = true;
                colvarContractTime.IsPrimaryKey = false;
                colvarContractTime.IsForeignKey = false;
                colvarContractTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarContractTime);
                
                TableSchema.TableColumn colvarContractProject = new TableSchema.TableColumn(schema);
                colvarContractProject.ColumnName = "Contract_project";
                colvarContractProject.DataType = DbType.String;
                colvarContractProject.MaxLength = 100;
                colvarContractProject.AutoIncrement = false;
                colvarContractProject.IsNullable = true;
                colvarContractProject.IsPrimaryKey = false;
                colvarContractProject.IsForeignKey = false;
                colvarContractProject.IsReadOnly = false;
                
                schema.Columns.Add(colvarContractProject);
                
                TableSchema.TableColumn colvarContractDetail = new TableSchema.TableColumn(schema);
                colvarContractDetail.ColumnName = "Contract_detail";
                colvarContractDetail.DataType = DbType.String;
                colvarContractDetail.MaxLength = 1073741823;
                colvarContractDetail.AutoIncrement = false;
                colvarContractDetail.IsNullable = true;
                colvarContractDetail.IsPrimaryKey = false;
                colvarContractDetail.IsForeignKey = false;
                colvarContractDetail.IsReadOnly = false;
                
                schema.Columns.Add(colvarContractDetail);
                
                TableSchema.TableColumn colvarOtherDetail = new TableSchema.TableColumn(schema);
                colvarOtherDetail.ColumnName = "other_detail";
                colvarOtherDetail.DataType = DbType.String;
                colvarOtherDetail.MaxLength = 1073741823;
                colvarOtherDetail.AutoIncrement = false;
                colvarOtherDetail.IsNullable = true;
                colvarOtherDetail.IsPrimaryKey = false;
                colvarOtherDetail.IsForeignKey = false;
                colvarOtherDetail.IsReadOnly = false;
                
                schema.Columns.Add(colvarOtherDetail);
                
                TableSchema.TableColumn colvarEnteringUserid = new TableSchema.TableColumn(schema);
                colvarEnteringUserid.ColumnName = "Entering_userid";
                colvarEnteringUserid.DataType = DbType.Int32;
                colvarEnteringUserid.MaxLength = 0;
                colvarEnteringUserid.AutoIncrement = false;
                colvarEnteringUserid.IsNullable = true;
                colvarEnteringUserid.IsPrimaryKey = false;
                colvarEnteringUserid.IsForeignKey = false;
                colvarEnteringUserid.IsReadOnly = false;
                
                schema.Columns.Add(colvarEnteringUserid);
                
                TableSchema.TableColumn colvarEnteringDeptID = new TableSchema.TableColumn(schema);
                colvarEnteringDeptID.ColumnName = "Entering_deptID";
                colvarEnteringDeptID.DataType = DbType.Int32;
                colvarEnteringDeptID.MaxLength = 0;
                colvarEnteringDeptID.AutoIncrement = false;
                colvarEnteringDeptID.IsNullable = true;
                colvarEnteringDeptID.IsPrimaryKey = false;
                colvarEnteringDeptID.IsForeignKey = false;
                colvarEnteringDeptID.IsReadOnly = false;
                
                schema.Columns.Add(colvarEnteringDeptID);
                
                TableSchema.TableColumn colvarDeptMasterId = new TableSchema.TableColumn(schema);
                colvarDeptMasterId.ColumnName = "Dept_master_ID";
                colvarDeptMasterId.DataType = DbType.Int32;
                colvarDeptMasterId.MaxLength = 0;
                colvarDeptMasterId.AutoIncrement = false;
                colvarDeptMasterId.IsNullable = true;
                colvarDeptMasterId.IsPrimaryKey = false;
                colvarDeptMasterId.IsForeignKey = false;
                colvarDeptMasterId.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptMasterId);
                
                TableSchema.TableColumn colvarDeptMasterTime = new TableSchema.TableColumn(schema);
                colvarDeptMasterTime.ColumnName = "Dept_master_time";
                colvarDeptMasterTime.DataType = DbType.DateTime;
                colvarDeptMasterTime.MaxLength = 0;
                colvarDeptMasterTime.AutoIncrement = false;
                colvarDeptMasterTime.IsNullable = true;
                colvarDeptMasterTime.IsPrimaryKey = false;
                colvarDeptMasterTime.IsForeignKey = false;
                colvarDeptMasterTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptMasterTime);
                
                TableSchema.TableColumn colvarDeptMasterStatus = new TableSchema.TableColumn(schema);
                colvarDeptMasterStatus.ColumnName = "Dept_master_status";
                colvarDeptMasterStatus.DataType = DbType.Int32;
                colvarDeptMasterStatus.MaxLength = 0;
                colvarDeptMasterStatus.AutoIncrement = false;
                colvarDeptMasterStatus.IsNullable = true;
                colvarDeptMasterStatus.IsPrimaryKey = false;
                colvarDeptMasterStatus.IsForeignKey = false;
                colvarDeptMasterStatus.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptMasterStatus);
                
                TableSchema.TableColumn colvarDeptMasterRemark = new TableSchema.TableColumn(schema);
                colvarDeptMasterRemark.ColumnName = "Dept_master_remark";
                colvarDeptMasterRemark.DataType = DbType.String;
                colvarDeptMasterRemark.MaxLength = 1073741823;
                colvarDeptMasterRemark.AutoIncrement = false;
                colvarDeptMasterRemark.IsNullable = true;
                colvarDeptMasterRemark.IsPrimaryKey = false;
                colvarDeptMasterRemark.IsForeignKey = false;
                colvarDeptMasterRemark.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptMasterRemark);
                
                TableSchema.TableColumn colvarTechMasterId = new TableSchema.TableColumn(schema);
                colvarTechMasterId.ColumnName = "Tech_master_ID";
                colvarTechMasterId.DataType = DbType.Int32;
                colvarTechMasterId.MaxLength = 0;
                colvarTechMasterId.AutoIncrement = false;
                colvarTechMasterId.IsNullable = true;
                colvarTechMasterId.IsPrimaryKey = false;
                colvarTechMasterId.IsForeignKey = false;
                colvarTechMasterId.IsReadOnly = false;
                
                schema.Columns.Add(colvarTechMasterId);
                
                TableSchema.TableColumn colvarTechMasterTime = new TableSchema.TableColumn(schema);
                colvarTechMasterTime.ColumnName = "Tech_master_time";
                colvarTechMasterTime.DataType = DbType.DateTime;
                colvarTechMasterTime.MaxLength = 0;
                colvarTechMasterTime.AutoIncrement = false;
                colvarTechMasterTime.IsNullable = true;
                colvarTechMasterTime.IsPrimaryKey = false;
                colvarTechMasterTime.IsForeignKey = false;
                colvarTechMasterTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarTechMasterTime);
                
                TableSchema.TableColumn colvarTechMasterStatus = new TableSchema.TableColumn(schema);
                colvarTechMasterStatus.ColumnName = "Tech_master_status";
                colvarTechMasterStatus.DataType = DbType.Int32;
                colvarTechMasterStatus.MaxLength = 0;
                colvarTechMasterStatus.AutoIncrement = false;
                colvarTechMasterStatus.IsNullable = true;
                colvarTechMasterStatus.IsPrimaryKey = false;
                colvarTechMasterStatus.IsForeignKey = false;
                colvarTechMasterStatus.IsReadOnly = false;
                
                schema.Columns.Add(colvarTechMasterStatus);
                
                TableSchema.TableColumn colvarTechMasterRemark = new TableSchema.TableColumn(schema);
                colvarTechMasterRemark.ColumnName = "Tech_master_remark";
                colvarTechMasterRemark.DataType = DbType.String;
                colvarTechMasterRemark.MaxLength = 1073741823;
                colvarTechMasterRemark.AutoIncrement = false;
                colvarTechMasterRemark.IsNullable = true;
                colvarTechMasterRemark.IsPrimaryKey = false;
                colvarTechMasterRemark.IsForeignKey = false;
                colvarTechMasterRemark.IsReadOnly = false;
                
                schema.Columns.Add(colvarTechMasterRemark);
                
                TableSchema.TableColumn colvarOfficeMasterId = new TableSchema.TableColumn(schema);
                colvarOfficeMasterId.ColumnName = "Office_master_ID";
                colvarOfficeMasterId.DataType = DbType.Int32;
                colvarOfficeMasterId.MaxLength = 0;
                colvarOfficeMasterId.AutoIncrement = false;
                colvarOfficeMasterId.IsNullable = true;
                colvarOfficeMasterId.IsPrimaryKey = false;
                colvarOfficeMasterId.IsForeignKey = false;
                colvarOfficeMasterId.IsReadOnly = false;
                
                schema.Columns.Add(colvarOfficeMasterId);
                
                TableSchema.TableColumn colvarOfficeMasterTime = new TableSchema.TableColumn(schema);
                colvarOfficeMasterTime.ColumnName = "Office_master_time";
                colvarOfficeMasterTime.DataType = DbType.DateTime;
                colvarOfficeMasterTime.MaxLength = 0;
                colvarOfficeMasterTime.AutoIncrement = false;
                colvarOfficeMasterTime.IsNullable = true;
                colvarOfficeMasterTime.IsPrimaryKey = false;
                colvarOfficeMasterTime.IsForeignKey = false;
                colvarOfficeMasterTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarOfficeMasterTime);
                
                TableSchema.TableColumn colvarOfficeMasterStatus = new TableSchema.TableColumn(schema);
                colvarOfficeMasterStatus.ColumnName = "Office_master_status";
                colvarOfficeMasterStatus.DataType = DbType.Int32;
                colvarOfficeMasterStatus.MaxLength = 0;
                colvarOfficeMasterStatus.AutoIncrement = false;
                colvarOfficeMasterStatus.IsNullable = true;
                colvarOfficeMasterStatus.IsPrimaryKey = false;
                colvarOfficeMasterStatus.IsForeignKey = false;
                colvarOfficeMasterStatus.IsReadOnly = false;
                
                schema.Columns.Add(colvarOfficeMasterStatus);
                
                TableSchema.TableColumn colvarOfficeMasterRemark = new TableSchema.TableColumn(schema);
                colvarOfficeMasterRemark.ColumnName = "Office_master_remark";
                colvarOfficeMasterRemark.DataType = DbType.String;
                colvarOfficeMasterRemark.MaxLength = 1073741823;
                colvarOfficeMasterRemark.AutoIncrement = false;
                colvarOfficeMasterRemark.IsNullable = true;
                colvarOfficeMasterRemark.IsPrimaryKey = false;
                colvarOfficeMasterRemark.IsForeignKey = false;
                colvarOfficeMasterRemark.IsReadOnly = false;
                
                schema.Columns.Add(colvarOfficeMasterRemark);
                
                TableSchema.TableColumn colvarBossId = new TableSchema.TableColumn(schema);
                colvarBossId.ColumnName = "Boss_ID";
                colvarBossId.DataType = DbType.Int32;
                colvarBossId.MaxLength = 0;
                colvarBossId.AutoIncrement = false;
                colvarBossId.IsNullable = true;
                colvarBossId.IsPrimaryKey = false;
                colvarBossId.IsForeignKey = false;
                colvarBossId.IsReadOnly = false;
                
                schema.Columns.Add(colvarBossId);
                
                TableSchema.TableColumn colvarBossTime = new TableSchema.TableColumn(schema);
                colvarBossTime.ColumnName = "Boss_time";
                colvarBossTime.DataType = DbType.DateTime;
                colvarBossTime.MaxLength = 0;
                colvarBossTime.AutoIncrement = false;
                colvarBossTime.IsNullable = true;
                colvarBossTime.IsPrimaryKey = false;
                colvarBossTime.IsForeignKey = false;
                colvarBossTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarBossTime);
                
                TableSchema.TableColumn colvarBossStatus = new TableSchema.TableColumn(schema);
                colvarBossStatus.ColumnName = "Boss_status";
                colvarBossStatus.DataType = DbType.Int32;
                colvarBossStatus.MaxLength = 0;
                colvarBossStatus.AutoIncrement = false;
                colvarBossStatus.IsNullable = true;
                colvarBossStatus.IsPrimaryKey = false;
                colvarBossStatus.IsForeignKey = false;
                colvarBossStatus.IsReadOnly = false;
                
                schema.Columns.Add(colvarBossStatus);
                
                TableSchema.TableColumn colvarBossRemark = new TableSchema.TableColumn(schema);
                colvarBossRemark.ColumnName = "Boss_remark";
                colvarBossRemark.DataType = DbType.String;
                colvarBossRemark.MaxLength = 1073741823;
                colvarBossRemark.AutoIncrement = false;
                colvarBossRemark.IsNullable = true;
                colvarBossRemark.IsPrimaryKey = false;
                colvarBossRemark.IsForeignKey = false;
                colvarBossRemark.IsReadOnly = false;
                
                schema.Columns.Add(colvarBossRemark);
                
                TableSchema.TableColumn colvarInTime = new TableSchema.TableColumn(schema);
                colvarInTime.ColumnName = "inTime";
                colvarInTime.DataType = DbType.DateTime;
                colvarInTime.MaxLength = 0;
                colvarInTime.AutoIncrement = false;
                colvarInTime.IsNullable = true;
                colvarInTime.IsPrimaryKey = false;
                colvarInTime.IsForeignKey = false;
                colvarInTime.IsReadOnly = false;
                
                schema.Columns.Add(colvarInTime);
                
                TableSchema.TableColumn colvarGuid = new TableSchema.TableColumn(schema);
                colvarGuid.ColumnName = "Guid";
                colvarGuid.DataType = DbType.Guid;
                colvarGuid.MaxLength = 0;
                colvarGuid.AutoIncrement = false;
                colvarGuid.IsNullable = true;
                colvarGuid.IsPrimaryKey = false;
                colvarGuid.IsForeignKey = false;
                colvarGuid.IsReadOnly = false;
                
                schema.Columns.Add(colvarGuid);
                
                TableSchema.TableColumn colvarDeptName = new TableSchema.TableColumn(schema);
                colvarDeptName.ColumnName = "DeptName";
                colvarDeptName.DataType = DbType.String;
                colvarDeptName.MaxLength = 50;
                colvarDeptName.AutoIncrement = false;
                colvarDeptName.IsNullable = true;
                colvarDeptName.IsPrimaryKey = false;
                colvarDeptName.IsForeignKey = false;
                colvarDeptName.IsReadOnly = false;
                
                schema.Columns.Add(colvarDeptName);
                
                TableSchema.TableColumn colvarUsername = new TableSchema.TableColumn(schema);
                colvarUsername.ColumnName = "username";
                colvarUsername.DataType = DbType.String;
                colvarUsername.MaxLength = 50;
                colvarUsername.AutoIncrement = false;
                colvarUsername.IsNullable = true;
                colvarUsername.IsPrimaryKey = false;
                colvarUsername.IsForeignKey = false;
                colvarUsername.IsReadOnly = false;
                
                schema.Columns.Add(colvarUsername);
                
                
                BaseSchema = schema;
                //add this schema to the provider
                //so we can query it later
                DataService.Providers["CXDB"].AddSchema("vw_provider_rep",schema);
            }
        }
        #endregion
        
        #region Query Accessor
	    public static Query CreateQuery()
	    {
		    return new Query(Schema);
	    }
	    #endregion
	    
	    #region .ctors
	    public VwProviderRep()
	    {
            SetSQLProps();
            SetDefaults();
            MarkNew();
        }
        public VwProviderRep(bool useDatabaseDefaults)
	    {
		    SetSQLProps();
		    if(useDatabaseDefaults)
		    {
				ForceDefaults();
			}
			MarkNew();
	    }
	    
	    public VwProviderRep(object keyID)
	    {
		    SetSQLProps();
		    LoadByKey(keyID);
	    }
    	 
	    public VwProviderRep(string columnName, object columnValue)
        {
            SetSQLProps();
            LoadByParam(columnName,columnValue);
        }
        
	    #endregion
	    
	    #region Props
	    
          
        [XmlAttribute("Id")]
        [Bindable(true)]
        public int Id 
	    {
		    get
		    {
			    return GetColumnValue<int>("ID");
		    }
            set 
		    {
			    SetColumnValue("ID", value);
            }
        }
	      
        [XmlAttribute("ProviderName")]
        [Bindable(true)]
        public string ProviderName 
	    {
		    get
		    {
			    return GetColumnValue<string>("ProviderName");
		    }
            set 
		    {
			    SetColumnValue("ProviderName", value);
            }
        }
	      
        [XmlAttribute("DeviceName")]
        [Bindable(true)]
        public string DeviceName 
	    {
		    get
		    {
			    return GetColumnValue<string>("DeviceName");
		    }
            set 
		    {
			    SetColumnValue("DeviceName", value);
            }
        }
	      
        [XmlAttribute("ShamTime")]
        [Bindable(true)]
        public DateTime? ShamTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("Sham_time");
		    }
            set 
		    {
			    SetColumnValue("Sham_time", value);
            }
        }
	      
        [XmlAttribute("ShamProject")]
        [Bindable(true)]
        public string ShamProject 
	    {
		    get
		    {
			    return GetColumnValue<string>("Sham_project");
		    }
            set 
		    {
			    SetColumnValue("Sham_project", value);
            }
        }
	      
        [XmlAttribute("ShamDetail")]
        [Bindable(true)]
        public string ShamDetail 
	    {
		    get
		    {
			    return GetColumnValue<string>("Sham_detail");
		    }
            set 
		    {
			    SetColumnValue("Sham_detail", value);
            }
        }
	      
        [XmlAttribute("XinghuTime")]
        [Bindable(true)]
        public DateTime? XinghuTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("Xinghu_time");
		    }
            set 
		    {
			    SetColumnValue("Xinghu_time", value);
            }
        }
	      
        [XmlAttribute("XinghuProject")]
        [Bindable(true)]
        public string XinghuProject 
	    {
		    get
		    {
			    return GetColumnValue<string>("Xinghu_project");
		    }
            set 
		    {
			    SetColumnValue("Xinghu_project", value);
            }
        }
	      
        [XmlAttribute("XinghuDetail")]
        [Bindable(true)]
        public string XinghuDetail 
	    {
		    get
		    {
			    return GetColumnValue<string>("Xinghu_detail");
		    }
            set 
		    {
			    SetColumnValue("Xinghu_detail", value);
            }
        }
	      
        [XmlAttribute("ContractTime")]
        [Bindable(true)]
        public DateTime? ContractTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("Contract_time");
		    }
            set 
		    {
			    SetColumnValue("Contract_time", value);
            }
        }
	      
        [XmlAttribute("ContractProject")]
        [Bindable(true)]
        public string ContractProject 
	    {
		    get
		    {
			    return GetColumnValue<string>("Contract_project");
		    }
            set 
		    {
			    SetColumnValue("Contract_project", value);
            }
        }
	      
        [XmlAttribute("ContractDetail")]
        [Bindable(true)]
        public string ContractDetail 
	    {
		    get
		    {
			    return GetColumnValue<string>("Contract_detail");
		    }
            set 
		    {
			    SetColumnValue("Contract_detail", value);
            }
        }
	      
        [XmlAttribute("OtherDetail")]
        [Bindable(true)]
        public string OtherDetail 
	    {
		    get
		    {
			    return GetColumnValue<string>("other_detail");
		    }
            set 
		    {
			    SetColumnValue("other_detail", value);
            }
        }
	      
        [XmlAttribute("EnteringUserid")]
        [Bindable(true)]
        public int? EnteringUserid 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Entering_userid");
		    }
            set 
		    {
			    SetColumnValue("Entering_userid", value);
            }
        }
	      
        [XmlAttribute("EnteringDeptID")]
        [Bindable(true)]
        public int? EnteringDeptID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Entering_deptID");
		    }
            set 
		    {
			    SetColumnValue("Entering_deptID", value);
            }
        }
	      
        [XmlAttribute("DeptMasterId")]
        [Bindable(true)]
        public int? DeptMasterId 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Dept_master_ID");
		    }
            set 
		    {
			    SetColumnValue("Dept_master_ID", value);
            }
        }
	      
        [XmlAttribute("DeptMasterTime")]
        [Bindable(true)]
        public DateTime? DeptMasterTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("Dept_master_time");
		    }
            set 
		    {
			    SetColumnValue("Dept_master_time", value);
            }
        }
	      
        [XmlAttribute("DeptMasterStatus")]
        [Bindable(true)]
        public int? DeptMasterStatus 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Dept_master_status");
		    }
            set 
		    {
			    SetColumnValue("Dept_master_status", value);
            }
        }
	      
        [XmlAttribute("DeptMasterRemark")]
        [Bindable(true)]
        public string DeptMasterRemark 
	    {
		    get
		    {
			    return GetColumnValue<string>("Dept_master_remark");
		    }
            set 
		    {
			    SetColumnValue("Dept_master_remark", value);
            }
        }
	      
        [XmlAttribute("TechMasterId")]
        [Bindable(true)]
        public int? TechMasterId 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Tech_master_ID");
		    }
            set 
		    {
			    SetColumnValue("Tech_master_ID", value);
            }
        }
	      
        [XmlAttribute("TechMasterTime")]
        [Bindable(true)]
        public DateTime? TechMasterTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("Tech_master_time");
		    }
            set 
		    {
			    SetColumnValue("Tech_master_time", value);
            }
        }
	      
        [XmlAttribute("TechMasterStatus")]
        [Bindable(true)]
        public int? TechMasterStatus 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Tech_master_status");
		    }
            set 
		    {
			    SetColumnValue("Tech_master_status", value);
            }
        }
	      
        [XmlAttribute("TechMasterRemark")]
        [Bindable(true)]
        public string TechMasterRemark 
	    {
		    get
		    {
			    return GetColumnValue<string>("Tech_master_remark");
		    }
            set 
		    {
			    SetColumnValue("Tech_master_remark", value);
            }
        }
	      
        [XmlAttribute("OfficeMasterId")]
        [Bindable(true)]
        public int? OfficeMasterId 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Office_master_ID");
		    }
            set 
		    {
			    SetColumnValue("Office_master_ID", value);
            }
        }
	      
        [XmlAttribute("OfficeMasterTime")]
        [Bindable(true)]
        public DateTime? OfficeMasterTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("Office_master_time");
		    }
            set 
		    {
			    SetColumnValue("Office_master_time", value);
            }
        }
	      
        [XmlAttribute("OfficeMasterStatus")]
        [Bindable(true)]
        public int? OfficeMasterStatus 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Office_master_status");
		    }
            set 
		    {
			    SetColumnValue("Office_master_status", value);
            }
        }
	      
        [XmlAttribute("OfficeMasterRemark")]
        [Bindable(true)]
        public string OfficeMasterRemark 
	    {
		    get
		    {
			    return GetColumnValue<string>("Office_master_remark");
		    }
            set 
		    {
			    SetColumnValue("Office_master_remark", value);
            }
        }
	      
        [XmlAttribute("BossId")]
        [Bindable(true)]
        public int? BossId 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Boss_ID");
		    }
            set 
		    {
			    SetColumnValue("Boss_ID", value);
            }
        }
	      
        [XmlAttribute("BossTime")]
        [Bindable(true)]
        public DateTime? BossTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("Boss_time");
		    }
            set 
		    {
			    SetColumnValue("Boss_time", value);
            }
        }
	      
        [XmlAttribute("BossStatus")]
        [Bindable(true)]
        public int? BossStatus 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Boss_status");
		    }
            set 
		    {
			    SetColumnValue("Boss_status", value);
            }
        }
	      
        [XmlAttribute("BossRemark")]
        [Bindable(true)]
        public string BossRemark 
	    {
		    get
		    {
			    return GetColumnValue<string>("Boss_remark");
		    }
            set 
		    {
			    SetColumnValue("Boss_remark", value);
            }
        }
	      
        [XmlAttribute("InTime")]
        [Bindable(true)]
        public DateTime? InTime 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("inTime");
		    }
            set 
		    {
			    SetColumnValue("inTime", value);
            }
        }
	      
        [XmlAttribute("Guid")]
        [Bindable(true)]
        public Guid? Guid 
	    {
		    get
		    {
			    return GetColumnValue<Guid?>("Guid");
		    }
            set 
		    {
			    SetColumnValue("Guid", value);
            }
        }
	      
        [XmlAttribute("DeptName")]
        [Bindable(true)]
        public string DeptName 
	    {
		    get
		    {
			    return GetColumnValue<string>("DeptName");
		    }
            set 
		    {
			    SetColumnValue("DeptName", value);
            }
        }
	      
        [XmlAttribute("Username")]
        [Bindable(true)]
        public string Username 
	    {
		    get
		    {
			    return GetColumnValue<string>("username");
		    }
            set 
		    {
			    SetColumnValue("username", value);
            }
        }
	    
	    #endregion
    
	    #region Columns Struct
	    public struct Columns
	    {
		    
		    
            public static string Id = @"ID";
            
            public static string ProviderName = @"ProviderName";
            
            public static string DeviceName = @"DeviceName";
            
            public static string ShamTime = @"Sham_time";
            
            public static string ShamProject = @"Sham_project";
            
            public static string ShamDetail = @"Sham_detail";
            
            public static string XinghuTime = @"Xinghu_time";
            
            public static string XinghuProject = @"Xinghu_project";
            
            public static string XinghuDetail = @"Xinghu_detail";
            
            public static string ContractTime = @"Contract_time";
            
            public static string ContractProject = @"Contract_project";
            
            public static string ContractDetail = @"Contract_detail";
            
            public static string OtherDetail = @"other_detail";
            
            public static string EnteringUserid = @"Entering_userid";
            
            public static string EnteringDeptID = @"Entering_deptID";
            
            public static string DeptMasterId = @"Dept_master_ID";
            
            public static string DeptMasterTime = @"Dept_master_time";
            
            public static string DeptMasterStatus = @"Dept_master_status";
            
            public static string DeptMasterRemark = @"Dept_master_remark";
            
            public static string TechMasterId = @"Tech_master_ID";
            
            public static string TechMasterTime = @"Tech_master_time";
            
            public static string TechMasterStatus = @"Tech_master_status";
            
            public static string TechMasterRemark = @"Tech_master_remark";
            
            public static string OfficeMasterId = @"Office_master_ID";
            
            public static string OfficeMasterTime = @"Office_master_time";
            
            public static string OfficeMasterStatus = @"Office_master_status";
            
            public static string OfficeMasterRemark = @"Office_master_remark";
            
            public static string BossId = @"Boss_ID";
            
            public static string BossTime = @"Boss_time";
            
            public static string BossStatus = @"Boss_status";
            
            public static string BossRemark = @"Boss_remark";
            
            public static string InTime = @"inTime";
            
            public static string Guid = @"Guid";
            
            public static string DeptName = @"DeptName";
            
            public static string Username = @"username";
            
	    }
	    #endregion
	    
	    
	    #region IAbstractRecord Members
        public new CT GetColumnValue<CT>(string columnName) {
            return base.GetColumnValue<CT>(columnName);
        }
        public object GetColumnValue(string columnName) {
            return base.GetColumnValue<object>(columnName);
        }
        #endregion
	    
    }
}
